﻿CREATE TABLE [dbo].[Person]
(
[PartyID] [int] NOT NULL,
[LastName] [nvarchar] (250) NULL,
[FirstName] [nvarchar] (50) NULL,
[MiddleName] [nvarchar] (50) NULL,
[PersonalTitle] [nvarchar] (50) NULL,
[Suffix] [nvarchar] (50) NULL,
[Nickname] [nvarchar] (50) NULL,
[Gender] [nchar] (1) NULL,
[BirthDate] [datetime] NULL,
[Height] [int] NULL,
[Weight] [int] NULL,
[MothersMaidenName] [nvarchar] (250) NULL,
[MaritalStatus] [nchar] (1) NULL,
[PersonalIdentificationNumber] [int] NULL,
[PassportNumber] [int] NULL,
[PassportExpireDate] [datetime] NULL,
[TotalYearsWorkExpirience] [int] NULL,
[Comment] [nvarchar] (250) NULL
) ON [PRIMARY]


